Introduction

The Independent Evaluation Group (IEG) is a vital unit within the World Bank Group with a mission to improve development results and evaluate the Bank Group’s self-evaluation and development risk management systems. The IEG World Bank Project Performance Ratings Dataset is a collection of ratings from all World Bank project assessments performed independently by IEG. Spanning over 30 years, The IEG World Bank Project Performance Ratings Dataset contains a collection of performance ratings from all the World Bank project assessments conducted by IEG. The dataset has data from over 11,260 project assessments covering more than 9,400 completed projects and is the longest-running project performance data collection of its kind. The ratings are based on a common objectives-based project evaluation methodology and use standardized scales to assign performance ratings.

Problem Statement

Section 1

In this section we will be delving into a regional analysis of World Bank financed projects. The World Bank operates in various administrative regions across the world, including Africa (AFR), East Asia Pacific (EAP), Europe and Central Asia (ECA), Latin America and Caribbean (LCR), Middle East and North Africa (MNA), and South Asia (SAR). This analysis will provide a comprehensive overview of the World Bank’s activities and their impact in each of these regions.

Question 1

Which region in the world has the maximum number of countries where the World Bank is financing different kinds of projects?

Output 1

It’s evident that the World Bank is providing financial support to projects across the six regions of the world. We observed that the African Region (AFR) consists of the highest number of countries (51) that were offered loans by the World Bank for various projects. From our analysis, we also noticed that the South Asian Region (SAR) consists of the least number of countries (9) that were offered loans by the World Bank for various projects.

Question 2

What are the top 5 countries in the world that have received the highest grant from the World Bank?

## `geom_line()`: Each group consists of only one observation.
## ℹ Do you need to adjust the group aesthetic?
## `geom_line()`: Each group consists of only one observation.
## ℹ Do you need to adjust the group aesthetic?

Output 2

From the line plot, we observed that the top 5 countries that have received the highest grant from the World Bank are in the following order: China > India > Mexico > Brazil > Pakistan. The amount that these countries received is the sum of all the grants that they received from the World Bank for various projects over the years.

Question 3

What are the top three sector boards with the most number of projects across all six regions?

## `summarise()` has grouped output by 'Region'. You can override using the
## `.groups` argument.
## `summarise()` has grouped output by 'Sector.Board'. You can override using the
## `.groups` argument.
## `summarise()` has grouped output by 'Region'. You can override using the
## `.groups` argument.

Output 3

From the stacked bar plot, we can observe that among the 28 sector boards, Agriculture & Rural Development tops the list with the highest number of projects across all six regions. Energy & Mining and Transport follow closely behind as the second and third sector boards with the most number of projects across all six regions.

Question 4

What is the percentage distribution of the projects according to the sector board in South Asia Region?

Output 4

In the South Asian region, a majority of projects are focused on environmental sustainability (59%) and poverty reduction (28%). Conversely, relatively few projects are dedicated to capital markets practices and financial systems, with only 1% to 2% of projects falling into these sector board categories.

Section 2

In this section, we’ll delve into the lending constraints for projects financed by the World Bank. We’ll focus on three key constraints: the agreement type between the borrower and the World Bank, and the total project lending cost, which is the total loan amount provided by the World Bank for a specific project and lending instrument type which are of three types Development Policy Financing(DPF), Investment Project Financing (IPF) and Program for Results Financing (PforR).

Question 1:

What are the top 2 agreement types signed between the borrower and the World Bank for all the projects approved after 2000?

## `summarise()` has grouped output by 'Agreement Type'. You can override using
## the `.groups` argument.

Output 1

According to the bubble chart analysis, the most frequently signed agreement types between borrowers and the World Bank for projects approved post-2000 are the International Development Association (IDA) and the International Bank for Reconstruction and Development (IBRD). The Recipient Executed Trust Fund (RETF) also features as a notable agreement type, albeit to a lesser extent.

Question 2:

For all the projects that have lending project cost more than 1 billion dollars, what was the Lending Instrument Type that was most commonly used?

Output 2

From the pie chart, we observed that the most commonly used Lending Instrument Type is Investment Project Financing (IPF) - 75.53% followed by Development Policy Financing (DPF) - 23.93%.

Section 3

In this section, we’ll delve into the analysis of the project success rate financed that were financed by the World Bank.

Question 1

Which region had the maximum number of projects with Satisfactory and Unsatisfactory outcomes for the overall performance of the project.

## `summarise()` has grouped output by 'Region'. You can override using the
## `.groups` argument.

Output 1

It can be observed that only South Asian Region (SAR) and Middle East and North Africa (MNA) regions have less projects with highly and moderately satisfactory rating. In comparison to that, African Region (AFR), East Asian Pacific (EAP) and Europe and Central Asia (ECA) regions have more number of projects with satisfactory rating. Particularly, it can be seen that AFR region has the highest number of projects with satisfactory rating. Also, African Region (AFR) contains high number of moderately satisfactory ratings.

Question 2

What is the median lending project cost for all the projects in India having Highly Satisfactory and Unsatisfactory Project Outcome?

Output 2

From the violin plot, we observed that the median lending project cost for all projects in India having Unsatisfactory project outcomes is 315.75 million dollars and Highly Satisfactory project outcome is 328 million dollars.

Summary and Conclusion

In conclusion, the World Bank is actively providing financial support to projects in the six regions of the world, with the African Region being the most benefited with 51 countries receiving loans for various projects. The top five countries receiving the highest grant from the World Bank are China, India, Mexico, Brazil, and Pakistan. The sector board with the highest number of projects across all six regions is Agriculture & Rural Development, followed by Energy & Mining and Transport. In the South Asian Region, most of the projects are focused on environmental sustainability and poverty reduction, with fewer projects dedicated to capital markets practices and financial systems. The visualization project provides a clear picture of the World Bank’s focus and efforts in supporting the growth and development of different countries and regions.

         Also, we observed that the World Bank primarily signs agreements with borrowers for projects approved post-2000 through the International Development Association (IDA) and the International Bank for Reconstruction and Development (IBRD). Although the Recipient Executed Trust Fund (RETF) is also used, it is used to a lesser extent. The most commonly used Lending Instrument Type is Investment Project Financing (IPF), accounting for 75.53% of all lending instruments, followed by Development Policy Financing (DPF) at 23.93%. These findings provide insight into the World Bank’s lending practices and highlight the importance of IDA and IBRD as the primary agreement types and IPF as the primary lending instrument type used for projects approved after 2000.

         In addition to this we observed that the South Asian Region (SAR) and the Middle East and North Africa (MNA) have fewer projects with high and moderate satisfaction ratings compared to other regions. On the other hand, the African Region (AFR), the East Asian Pacific (EAP), and the Europe and Central Asia (ECA) regions have a higher number of projects with satisfactory ratings, with the AFR region having the highest number of satisfactory ratings. The violin plot also shows that for India, the median lending project cost for projects with unsatisfactory outcomes is 315.75 million dollars, while for projects with highly satisfactory outcomes, it is 328 million dollars. These findings provide valuable information about the performance of World Bank projects across different regions and their impact on the countries they serve.